Adm 1 
Aadaki sql sorgusunu NebimV3Master veritabannda altrn.

PHP Kod:
USE NebimV3Master
GO
DECLARE @ReportFileName Char200 = SPACE(0)
DECLARE @IsDefault    bit = 0
SELECT @ReportFileName  = ReportFileName , @IsDefault = IsDefault FROM bsReportQuery WHERE ReportName = N'V3Integrator' AND QueryName  = N'ASF_URUNFIYAT'
DELETE bsReportQuery WHERE ReportName = N'V3Integrator' AND QueryName = N'ASF_URUNFIYAT'
INSERT INTO bsReportQuery (ReportName, DefaultFilterCols, ParameteredFields, NotBeFilteredFields , IsPivotAvailable, IsDefault , ReportFileName , QueryName, QueryText)
SELECT ReportName            = N'V3Integrator'
, DefaultFilterCols        = N''
, ParameteredFields        = N''
, NotBeFilteredFields    = N''
, IsPivotAvailable        = N'0'
, IsDefault                = @IsDefault
, ReportFileName        = N''
, QueryName                = N'ASF_URUNFIYAT'
, QueryText                = 
N'
SELECT * FROM ASF_URUNFIYAT(''TR'',''EAN13'','''',999999)                                        
'
GO 


Adm 2 

Aadaki sql sorgusunu irket veritabannda altrn

PHP Kod:
IF OBJECT_ID('ASF_URUNFIYAT') IS NOT NULL DROP FUNCTION ASF_URUNFIYAT
GO
CREATE FUNCTION ASF_URUNFIYAT (@LangCode Char5,@BarcodeTypeCode Char20,@PriceGroupCode Char20, @LastNHour int ) 
RETURNS TABLE 
AS RETURN
(
SELECT  Product.* 
, ColorCode                             = prItemVariant.ColorCode
, ColorDescription                        = cdColorDesc.ColorDescription
, ItemDim1Code                          = prItemVariant.ItemDim1Code
, ItemDim2Code                          = prItemVariant.ItemDim2Code
, ItemDim3Code                          = prItemVariant.ItemDim3Code 
, VatRate                               = ISNULL((SELECT VatRate FROM cdVat WITH(NOLOCK)
WHERE cdVat.VatCode = Product.ItemTaxGrCode)
,SPACE(0))
, Price1                   = ISNULL((SELECT TOP 1 Price FROM [prItemBasePrice]
WHERE [prItemBasePrice].[BasePriceCode]='1' AND [prItemBasePrice].ItemTypeCode=Product.ProductTypeCode
AND [prItemBasePrice].ItemCode=Product.ProductCode), SPACE(0))   
, Price2                   = ISNULL((SELECT TOP 1 Price FROM [prItemBasePrice]
WHERE [prItemBasePrice].[BasePriceCode]='2' AND [prItemBasePrice].ItemTypeCode=Product.ProductTypeCode
AND [prItemBasePrice].ItemCode=Product.ProductCode), SPACE(0))     
, Price3                   = ISNULL((SELECT TOP 1 Price FROM [prItemBasePrice]
WHERE [prItemBasePrice].[BasePriceCode]='3' AND [prItemBasePrice].ItemTypeCode=Product.ProductTypeCode
AND [prItemBasePrice].ItemCode=Product.ProductCode), SPACE(0))  
, Price4                   = ISNULL((SELECT TOP 1 Price FROM [prItemBasePrice]
WHERE [prItemBasePrice].[BasePriceCode]='4' AND [prItemBasePrice].ItemTypeCode=Product.ProductTypeCode
AND [prItemBasePrice].ItemCode=Product.ProductCode), SPACE(0))
, Price5                   = ISNULL((SELECT TOP 1 Price FROM [prItemBasePrice]
WHERE [prItemBasePrice].[BasePriceCode]='5' AND [prItemBasePrice].ItemTypeCode=Product.ProductTypeCode
AND [prItemBasePrice].ItemCode=Product.ProductCode), SPACE(0))
, Price6                   = ISNULL((SELECT TOP 1 Price FROM [prItemBasePrice]
WHERE [prItemBasePrice].[BasePriceCode]='6' AND [prItemBasePrice].ItemTypeCode=Product.ProductTypeCode
AND [prItemBasePrice].ItemCode=Product.ProductCode), SPACE(0))
, Price7                   = ISNULL((SELECT TOP 1 Price FROM [prItemBasePrice]
WHERE [prItemBasePrice].[BasePriceCode]='7' AND [prItemBasePrice].ItemTypeCode=Product.ProductTypeCode
AND [prItemBasePrice].ItemCode=Product.ProductCode), SPACE(0))
, Price8                   = ISNULL((SELECT TOP 1 Price FROM [prItemBasePrice]
WHERE [prItemBasePrice].[BasePriceCode]='8' AND [prItemBasePrice].ItemTypeCode=Product.ProductTypeCode
AND [prItemBasePrice].ItemCode=Product.ProductCode), SPACE(0))  
, Warehouse1InventoryQty    = ISNULL((SELECT SUM(AvailableInventoryQty1) FROM ItemInventory  AS Warehouse1Inv WITH(NOLOCK)
WHERE 
Warehouse1Inv.ItemTypeCode        = prItemVariant.ItemTypeCode 
AND Warehouse1Inv.ItemCode        = prItemVariant.ItemCode
AND Warehouse1Inv.ColorCode       = prItemVariant.ColorCode
AND Warehouse1Inv.ItemDim1Code    = prItemVariant.ItemDim1Code 
AND Warehouse1Inv.ItemDim2Code    = prItemVariant.ItemDim2Code
AND Warehouse1Inv.ItemDim3Code    = prItemVariant.ItemDim3Code
AND Warehouse1Inv.WarehouseCode	= '1-2-1') ,0)
, AttributeType01                 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 1 ), SPACE(0))
, AttributeType02                 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 2 ), SPACE(0))
, AttributeType03                 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 3 ), SPACE(0))
, AttributeType04                 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 4 ), SPACE(0))
, AttributeType05                 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 5 ), SPACE(0))
, AttributeType06                 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 6 ), SPACE(0))
, AttributeType07                 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 7 ), SPACE(0))
, AttributeType08                 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 8 ), SPACE(0))
, AttributeType09                 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 9 ), SPACE(0))
, AttributeType10                 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 10), SPACE(0))
, AttributeType11                 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 11), SPACE(0))
, AttributeType12                 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 12), SPACE(0))
, AttributeType13                 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 13), SPACE(0))
, AttributeType14                 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 14), SPACE(0))
, AttributeType15                 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 15), SPACE(0))
, AttributeType16                 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 16), SPACE(0))
, AttributeType17                 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 17), SPACE(0))
, AttributeType18                 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 18), SPACE(0))
, AttributeType19                 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 19), SPACE(0))
, AttributeType20                 = ISNULL((SELECT AttributeTypeDescription FROM ItemAttributeType(@LangCode) where ItemTypeCode = 1 AND AttributeTypeCode = 20), SPACE(0))
--, ProductHierarchyLevel01Desc                  = ISNULL((SELECT ProductHierarchyLevel01Desc FROM dfProductHierarchyLevelNames where LangCode = @LangCode), SPACE(0))
--, ProductHierarchyLevel02Desc                  = ISNULL((SELECT ProductHierarchyLevel02Desc FROM dfProductHierarchyLevelNames where LangCode = @LangCode), SPACE(0))
--, ProductHierarchyLevel03Desc                  = ISNULL((SELECT ProductHierarchyLevel03Desc FROM dfProductHierarchyLevelNames where LangCode = @LangCode), SPACE(0))
--, ProductHierarchyLevel04Desc                  = ISNULL((SELECT ProductHierarchyLevel04Desc FROM dfProductHierarchyLevelNames where LangCode = @LangCode), SPACE(0))
--, ProductHierarchyLevel05Desc                  = ISNULL((SELECT ProductHierarchyLevel05Desc FROM dfProductHierarchyLevelNames where LangCode = @LangCode), SPACE(0))
--, ProductHierarchyLevel06Desc                  = ISNULL((SELECT ProductHierarchyLevel06Desc FROM dfProductHierarchyLevelNames where LangCode = @LangCode), SPACE(0))
--, ProductHierarchyLevel07Desc                  = ISNULL((SELECT ProductHierarchyLevel07Desc FROM dfProductHierarchyLevelNames where LangCode = @LangCode), SPACE(0))
--, ProductHierarchyLevel08Desc                  = ISNULL((SELECT ProductHierarchyLevel08Desc FROM dfProductHierarchyLevelNames where LangCode = @LangCode), SPACE(0))
--, ProductHierarchyLevel09Desc                  = ISNULL((SELECT ProductHierarchyLevel09Desc FROM dfProductHierarchyLevelNames where LangCode = @LangCode), SPACE(0))
--, ProductHierarchyLevel10Desc                  = ISNULL((SELECT ProductHierarchyLevel10Desc FROM dfProductHierarchyLevelNames where LangCode = @LangCode), SPACE(0))
, ItemPhotoPath                         = ISNULL((SELECT FolderPath FROM dfGlobalFolder WHERE GlobalDefaultCode = 1 AND FolderCode = N'ProductPhotoPath'),SPACE(0))
, Barcode                               = ISNULL((SELECT MAX(Barcode) FROM prItemBarcode WITH(NOLOCK)
WHERE       prItemBarcode.BarcodeTypeCode     = @BarcodeTypeCode
AND prItemBarcode.ItemTypeCode        = prItemVariant.ItemTypeCode
AND prItemBarcode.ItemCode                  = prItemVariant.ItemCode
AND prItemBarcode.ColorCode                 = prItemVariant.ColorCode                                                          AND prItemBarcode.ItemDim1Code        = prItemVariant.ItemDim1Code
AND prItemBarcode.ItemDim2Code        = prItemVariant.ItemDim2Code                                                      AND prItemBarcode.ItemDim3Code        = prItemVariant.ItemDim3Code) , SPACE(0))
, ItemDim1SortOrder                     = cdItemDim1.SortOrder
, ItemDim2SortOrder                     = cdItemDim2.SortOrder
, ItemDim3SortOrder                     = cdItemDim3.SortOrder
, ISNULL(prItemNotes.PlainText,'') ProductOption
, ISNULL(prItemNotes.Notes,'') Notes
FROM ProductFilterWithDescription ('TR')   AS Product
INNER JOIN prItemVariant WITH(NOLOCK)
ON prItemVariant.ItemCode            = Product.ProductCode 
AND prItemVariant.ItemTypeCode        = Product.ProductTypeCode 
INNER JOIN cdItemDim1 WITH(NOLOCK)
ON cdItemDim1.ItemDim1Code            = prItemVariant.ItemDim1Code
INNER JOIN cdItemDim2 WITH(NOLOCK)
ON cdItemDim2.ItemDim2Code            = prItemVariant.ItemDim2Code
INNER JOIN cdItemDim3 WITH(NOLOCK)
ON cdItemDim3.ItemDim3Code            = prItemVariant.ItemDim3Code
INNER JOIN cdItem WITH(NOLOCK)
ON cdItem.ItemCode                    = Product.ProductCode 
AND cdItem.ItemTypeCode                = Product.ProductTypeCode 
LEFT JOIN prItemNotes prItemNotes WITH(NOLOCK) ON prItemNotes.ItemCode = Product.ProductCode

LEFT JOIN    (
SELECT ItemCode,ItemTypeCode,ColorCode,ItemDim1Code,ItemDim2Code,ItemDim3Code,
SUM(AvailableInventoryQty1) AvailableInventory 
FROM ItemInventory     WITH (NOLOCK)
GROUP BY ItemCode,ItemTypeCode,ColorCode,ItemDim1Code,ItemDim2Code,ItemDim3Code
) AS WarehouseInv ON WarehouseInv.ItemTypeCode        = prItemVariant.ItemTypeCode 
AND WarehouseInv.ItemCode            = prItemVariant.ItemCode
AND WarehouseInv.ColorCode        = prItemVariant.ColorCode
AND WarehouseInv.ItemDim1Code        = prItemVariant.ItemDim1Code 
AND WarehouseInv.ItemDim2Code        = prItemVariant.ItemDim2Code
AND WarehouseInv.ItemDim3Code        = prItemVariant.ItemDim3Code   
LEFT OUTER JOIN cdItemDesc WITH (NOLOCK) ON cdItemDesc.ItemTypeCode=Product.ProductTypeCode
AND cdItemDesc.ItemCode=Product.ProductCode
AND cdItemDesc.LangCode=@LangCode    
LEFT OUTER JOIN cdColorDesc WITH (NOLOCK) ON cdColorDesc.ColorCode=prItemVariant.ColorCode
AND   cdColorDesc.LangCode=@LangCode    
WHERE Product.IsBlocked    = 0 
AND Product.UseInternet= 1
AND cdItem.IsBlocked = 0
AND Product.ProductTypeCode=1
AND (EXISTS (SELECT * FROM trStock WITH(NOLOCK) 
WHERE trStock.ItemTypeCode     = prItemVariant.ItemTypeCode        
AND trStock.ItemCode     = prItemVariant.ItemCode
AND trStock.ColorCode     = prItemVariant.ColorCode
AND trStock.ItemDim1Code = prItemVariant.ItemDim1Code
AND trStock.ItemDim2Code = prItemVariant.ItemDim2Code
AND trStock.OperationDate BETWEEN DATEADD(HOUR , -1 * '999999', GETDATE() ) AND  GETDATE()  )
OR (cdItem.LastUpdatedDate BETWEEN DATEADD(HOUR , -1 * '999999', GETDATE() ) AND  GETDATE() ) 
OR (cdItemDesc.LastUpdatedDate BETWEEN DATEADD(HOUR , -1 * '999999', GETDATE() ) AND  GETDATE())  
OR (prItemVariant.LastUpdatedDate BETWEEN DATEADD(HOUR , -1 * '999999', GETDATE() ) AND  GETDATE()) 
)
)

GO

bu sorgu temel fiyattan getirmektedir
SQL Sorgularn altrdktan sonra ISS y cmd satrn ynetici olarak ap resetlerseniz 
entegratr sorguyu grr.
